SOP_POPLink (SOP60100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP60100

Display Name: SOP_POPLink
Physical Name: SOP60100
Technical Name: SOP_POPLink

Group Display Name: Sales Distribution
Group Technical Name: Sales Distribution

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
2	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
3	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
4	CMPNTSEQ	Component Sequence	Long Integer	LI_Sequence_Number	10
5	PONUMBER	PO Number	String	STR17_POP_Number	17
6	ORD	Ord	Long Integer	LI_Sequence_Number	10
7	RCTINVCERRORS	Receipt Invoicing Errors	Long Integer	ML_ReceiptInvoicingErrors	0
8	RCPTCOST	Receipt Cost	Currency	DLR17_RBS0_UTR$	17
9	RCPTPRIORITY	Receipt Priority	Integer	INT	0
10	QTYONPO	QTY On PO	Currency	DLR17_QTY_RBS0_UTR	17
11	QTYONPOBASE	QTY On PO In Base	Currency	DLR17_QTY_RBS0_UTR	17
12	QTYRECVD	QTY Received	Currency	DLR17_QTY_RBS0_UTR	17
13	QTYRECINBASE	QTY Received In Base	Currency	DLR17_QTY_RBS0_UTR	17
14	RQSTFFDATE	Requested Fulfillment Date	Date	DATE	6
15	QTYBSUOM	QTY In Base U Of M	Currency	DLR17_QTY_RBS0_STR	17
16	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SOP_POPLink'].LOCNCODE AS 'SOP_POPLink-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SOP60100 AS ['SOP_POPLink'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SOP_POPLink'].LOCNCODE = ['Site Setup'].LOCNCODE
17	ITEMDESC	Item Description	String	STR100	100
18	DOCDATE	Document Date	Date	DT	8
19	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.